package pro.shushi.pamirs.demo.core.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;


@Mapper
public interface DemoItemMapper {
    @Select("<script>select sum(item_price) as item_price,sum(inventory_quantity) as inventory_quantity,category_id from ${table}  as core_demo_item ${where}  group by category_id</script>")
    List<Map<String, Object>> groupByCategoryId(@Param("table") String table,@Param("where") String where);
}
